[IN] 4.8 CSV files received are separated by a comma instead of being displayed in Excel Columns

1. Topic

Certain .CSV files open as a long string of characters and cannot be easily read. The information below provides solutions

mceclip0.png

 

2. Fixes

2.1: Solution 1

Open the .CSV file with Notepad. Create a new line on top and type: 'SEP=,' (without the '').

File -> Save as -> (select All Files) -> Name.CSV

mceclip1.png

 

2.2: Solution 2

Open Notepad++. Go to Plugins -> Plugins Admin... -> tick TextFX Character -> Install

mceclip2.png

Restart Notepad++.

Open the .CSV file in Notepad ++ -> select a comma (,) -> press Ctrl+C

Press Ctrl+A -> navigate as below:

mceclip4.png

This should be the result:

mceclip5.png